# -*- coding: utf-8 -*-

from __future__ import unicode_literals

from django.db import migrations


class Migration(migrations.Migration):

    dependencies = [
        ('WEIPDCRM', '0033_package_view'),
    ]

    operations = [
        migrations.RunSQL(
            "SET FOREIGN_KEY_CHECKS = 0;"
        ),
        migrations.RunSQL(
            "TRUNCATE TABLE `WEIPDCRM_osversion`;"
        ),
        migrations.RunSQL(
            "INSERT INTO `WEIPDCRM_osversion` VALUES (1,1,'2017-02-23 20:26:07.999147','7.0','11A465/11A466',''),(2,1,'2017-02-23 20:26:27.234628','7.0.1','11A470a',''),(3,1,'2017-02-23 20:26:35.694836','7.0.2','11A501',''),(4,1,'2017-02-23 20:26:45.968797','7.0.3','11B511',''),(5,1,'2017-02-23 20:26:55.878741','7.0.4','11B554a',''),(6,1,'2017-02-23 20:27:05.722476','7.0.5','11B601',''),(7,1,'2017-02-23 20:27:14.824492','7.0.6','11B651',''),(8,1,'2017-02-23 20:27:41.058626','7.1','11D167/11D169',''),(9,1,'2017-02-23 20:27:50.743600','7.1.1','11D201',''),(10,1,'2017-02-23 20:27:59.778728','7.1.2','11D257',''),(11,1,'2017-02-23 20:28:22.121619','8.0','12A365/12A366',''),(12,1,'2017-02-23 20:28:37.962418','8.0.1','12A402',''),(13,1,'2017-02-23 20:28:47.220831','8.0.2','12A405',''),(14,1,'2017-02-23 20:29:09.496014','8.1','12B410/12B411',''),(15,1,'2017-02-23 20:29:31.951212','8.1.1','12B435/12B436',''),(16,1,'2017-02-23 20:29:41.245193','8.1.2','12B440',''),(17,1,'2017-02-23 20:29:49.558666','8.1.3','12B466',''),(18,1,'2017-02-23 20:30:01.607079','8.2','12D508',''),(19,1,'2017-02-23 20:30:22.195267','8.3','12F69/12F70',''),(20,1,'2017-02-23 20:30:34.750614','8.4','12H143',''),(21,1,'2017-02-23 20:30:48.858743','8.4.1','12H321',''),(22,1,'2017-02-23 20:31:10.043252','9.0','13A340/13A342/13A343/13A344',''),(23,1,'2017-02-23 20:31:25.447806','9.0.1','13A404/13A405',''),(24,1,'2017-02-23 20:31:35.242925','9.0.2','13A452',''),(25,1,'2017-02-23 20:31:46.694711','9.1','13B143',''),(26,1,'2017-02-23 20:32:00.588886','9.2','13C75',''),(27,1,'2017-02-23 20:32:14.842875','9.2.1','13D15/13D20',''),(28,1,'2017-02-23 20:32:38.918867','9.3','13E233/13E234/13E236/13E237',''),(29,1,'2017-02-23 20:32:52.486621','9.3.1','13E238',''),(30,1,'2017-02-23 20:33:01.981245','9.3.2','13F69/13F72',''),(31,1,'2017-02-23 20:33:10.812760','9.3.3','13G34',''),(32,1,'2017-02-23 20:33:18.732530','9.3.4','13G35',''),(33,1,'2017-02-23 20:33:25.798013','9.3.5','13G36',''),(34,1,'2017-02-23 20:34:16.648571','10.0','14A346',''),(35,1,'2017-02-23 20:34:23.140254','10.0.1','14A403',''),(36,1,'2017-02-23 20:34:36.279151','10.0.2','14A456',''),(37,1,'2017-02-23 20:34:43.053013','10.0.3','14A551',''),(38,1,'2017-02-23 20:34:55.708453','10.1','14B72/14B72c',''),(39,1,'2017-02-23 20:35:17.208134','10.1.1','14B100/14B150',''),(40,1,'2017-02-23 20:35:28.518381','10.2','14C92',''),(41,1,'2017-02-23 20:35:38.504536','10.2.1','14D27',''),(42,1,'2018-03-29 12:56:45.027024','10.3','14E277',''),(43,1,'2018-03-29 12:56:58.260688','10.3.1','14E304',''),(44,1,'2018-03-29 12:57:25.641240','10.3.2','14F89/14F8089/14F90/14F91',''),(45,1,'2018-03-29 12:57:36.342312','10.3.3','14G60',''),(46,1,'2018-03-29 12:57:50.367078','11.0','15A372',''),(47,1,'2018-03-29 12:58:10.571310','11.0.1','15A402/15A403/15A8391',''),(48,1,'2018-03-29 12:58:21.500627','11.0.2','15A421',''),(49,1,'2018-03-29 12:58:34.072932','11.0.3','15A432',''),(50,1,'2018-03-29 12:58:44.405462','11.1','15B93/15B101',''),(51,1,'2018-03-29 12:58:53.394225','11.1.1','15B150',''),(52,1,'2018-03-29 12:59:01.854353','11.1.2','15B202',''),(53,1,'2018-03-29 12:59:11.187375','11.2','15C114',''),(54,1,'2018-03-29 12:59:19.928616','11.2.1','15C153',''),(55,1,'2018-03-29 12:59:28.075789','11.2.2','15C202',''),(56,1,'2018-03-29 12:59:36.596155','11.2.5','15D60',''),(57,1,'2018-03-29 12:59:49.828635','11.2.6','15D100',''),(58,1,'2018-03-29 12:59:49.828635','11.3','15E216',''),(59,1,'2018-03-29 12:59:49.828635','11.3.1','15E302',''),(60,1,'2018-03-29 12:59:49.828635','11.4','15F79',''),(61,1,'2018-03-29 12:59:49.828635','11.4.1','15G77',''),(62,1,'2020-03-01 05:10:39.350604','12.0','16A366',''),(63,1,'2020-03-01 05:10:51.285126','12.0.1','16A405',''),(64,1,'2020-03-01 05:11:06.191362','12.1','16B92',''),(65,1,'2020-03-01 05:11:15.787436','12.1.1','16C50',''),(66,1,'2020-03-01 05:11:26.858752','12.1.2','16C104',''),(67,1,'2020-03-01 05:11:35.225411','12.1.3','16D40',''),(68,1,'2020-03-01 05:11:43.675253','12.1.4','16D57',''),(69,1,'2020-03-01 05:11:54.071566','12.2','16E227',''),(70,1,'2020-03-01 05:12:04.052789','12.3','16F156',''),(71,1,'2020-03-01 05:12:14.277185','12.3.1','16F203',''),(72,1,'2020-03-01 05:12:24.998135','12.3.2','16F250',''),(73,1,'2020-03-01 05:12:33.548946','12.4','16G77',''),(74,1,'2020-03-01 05:12:43.459036','12.4.1','16G102',''),(75,1,'2020-03-01 05:12:53.752324','12.4.2','16G114',''),(76,1,'2020-03-01 05:13:02.753567','12.4.3','16G130',''),(77,1,'2020-03-01 05:13:12.347199','12.4.4','16G140',''),(78,1,'2020-03-01 05:13:21.695863','12.4.5','16G161',''),(79,1,'2020-03-01 05:13:30.271264','13.0','17A577',''),(80,1,'2020-03-01 05:13:38.651230','13.1','17A844',''),(81,1,'2020-03-01 05:13:46.717746','13.1.1','17A854',''),(82,1,'2020-03-01 05:13:56.417886','13.1.2','17A860/17A861',''),(83,1,'2020-03-01 05:14:04.078357','13.1.3','17A878',''),(84,1,'2020-03-01 05:14:13.515451','13.2','17B84',''),(85,1,'2020-03-01 05:14:20.941320','13.2.1','17B90',''),(86,1,'2020-03-01 05:14:28.985384','13.2.2','17B102',''),(87,1,'2020-03-01 05:14:38.065588','13.2.3','17B111',''),(88,1,'2020-03-01 05:14:46.006616','13.3','17C54',''),(89,1,'2020-03-01 05:14:52.883235','13.3.1','17D50','');"
        ),
        migrations.RunSQL(
            "TRUNCATE TABLE `WEIPDCRM_devicetype`;"
        ),
        migrations.RunSQL(
            "INSERT INTO `WEIPDCRM_devicetype` VALUES (1,1,'2017-02-23 20:40:06.081991','iPod Touch (4th generation)','iPod4,1','A1367',''),(2,1,'2017-02-23 20:40:31.481875','iPod Touch (5th generation)','iPod5,1','A1421/A1509',''),(3,1,'2017-02-23 20:41:11.038126','iPod Touch (6th generation)','iPod7,1','A1574',''),(4,1,'2017-02-23 20:42:41.308309','iPad (3rd generation)','iPad3,1/iPad3,2/iPad3,3','A1416/A1403/A1430',''),(5,1,'2017-02-23 20:43:14.274605','iPad (4th generation)','iPad3,4/iPad3,5/iPad3,6','A1458/A1459/A1460',''),(6,1,'2017-02-23 20:43:46.963973','iPad Air','iPad4,1/iPad4,2/iPad4,3','A1474/A1475/A1476',''),(7,1,'2017-02-23 20:44:19.633470','iPad Air 2','iPad5,3/iPad5,4','A1566/A1567',''),(8,1,'2017-02-23 20:45:02.227205','iPad Mini 2','iPad4,4/iPad4,5/iPad4,6','A1489/A1490/A1491',''),(9,1,'2017-02-23 20:45:35.967523','iPad Mini 3','iPad4,7/iPad4,8/iPad4,9','A1599/A1600/A1601',''),(10,1,'2017-02-23 20:46:04.407481','iPad Mini 4','iPad5,1/iPad5,2','A1538/A1550',''),(11,1,'2017-02-23 20:46:28.145065','iPad Pro 12.9-inch (1st generation)','iPad6,7/iPad6,8','A1584/A1652',''),(12,1,'2017-02-23 20:46:53.761824','iPad Pro 9.7-inch','iPad6,3/iPad6,4','A1673/A1674/A1675',''),(13,1,'2017-02-23 20:48:19.262702','iPhone 4','iPhone3,1/iPhone3,2/iPhone3,3','A1349/A1332',''),(14,1,'2017-02-23 20:48:43.484709','iPhone 4S','iPhone4,1','A1431/A1387',''),(15,1,'2017-02-23 20:49:18.146555','iPhone 5','iPhone5,1/iPhone5,2','A1428/A1429/A1442',''),(16,1,'2017-02-23 20:50:02.325370','iPhone 5C','iPhone5,3/iPhone5,4','A1532/A1456/A1507/A1529/A1516/A1526',''),(17,1,'2017-02-23 20:50:46.258417','iPhone 5S','iPhone6,1/iPhone6,2','A1533/A1453/A1457/A1530/A1518/A1528',''),(18,1,'2017-02-23 20:51:15.283135','iPhone 6','iPhone7,2','A1549/A1586/A1589',''),(19,1,'2017-02-23 20:51:37.017890','iPhone 6 Plus','iPhone7,1','A1522/A1524/A1593',''),(20,1,'2017-02-23 20:52:07.123383','iPhone 6S','iPhone8,1','A1633/A1688/A1700/A1691',''),(21,1,'2017-02-23 20:52:27.778077','iPhone 6S Plus','iPhone8,2','A1634/A1687/A1699/A1690',''),(22,1,'2017-02-23 20:52:54.655229','iPhone SE','iPhone8,4','A1662/A1723/A1724',''),(23,1,'2017-02-23 20:53:26.954602','iPhone 7','iPhone9,1/iPhone9,3','A1660/A1778/A1779',''),(24,1,'2017-02-23 20:53:54.574175','iPhone 7 Plus','iPhone9,2/iPhone9,4','A1661/A1784/A1785',''),(25,1,'2018-04-02 08:51:29.527016','iPhone 8','iPhone10,1/iPhone10,4','A1863/A1906/A1907/A1905',''),(26,1,'2018-04-02 08:53:08.730273','iPhone 8 Plus','iPhone10,2/iPhone10,5','A1864/A1898/A1899/A1897',''),(27,1,'2018-04-02 08:53:40.315911','iPhone X','iPhone10,3/iPhone10,6','A1865/A1902/A1901',''),(28,1,'2018-04-02 08:53:40.315911','iPhone XS','iPhone11,2','A1920/A2097/A2098/A2099/A2100',''),(29,1,'2018-04-02 08:53:40.315911','iPhone XS Max','iPhone11,4/iPhone11,6','A1921/A2101/A2102/A2103/A2104',''),(30,1,'2018-04-02 08:53:40.315911','iPhone XR','iPhone11,8','A1984/A2105/A2106/A2107/A2108',''),(31,1,'2020-03-01 05:17:54.137223','iPhone 11','iPhone12,1','A2111/A2221/A2223',''),(32,1,'2020-03-01 05:18:26.489601','iPhone 11 Pro','iPhone12,3','A2160/A2215/A2217',''),(33,1,'2020-03-01 05:18:50.462935','iPhone 11 Pro Max','iPhone12,5','A2161/A2218/A2220',''),(34,1,'2020-03-01 05:21:24.614440','iPod Touch (7th generation)','iPod9,1','A2178',''),(35,1,'2020-03-01 05:24:03.273567','iPad (5th generation)','iPad6,11/iPad6,12','A1822/A1823',''),(36,1,'2020-03-01 05:24:36.833686','iPad (6th generation)','iPad7,5/iPad7,6','A1893/A1954',''),(37,1,'2020-03-01 05:25:16.838530','iPad (7th generation)','iPad7,11/iPad7,12','A2197/A2198/A2200',''),(38,1,'2020-03-01 05:26:11.108311','iPad Mini (5th generation)','iPad11,1/iPad11,2','A2133/A2124/A2126/A2125',''),(39,1,'2020-03-01 05:26:53.612527','iPad Air (3rd generation)','iPad11,3/iPad11,4','A2152/A2123/A2153/A2154',''),(40,1,'2020-03-01 05:28:57.410311','iPad Pro 12.9-inch (2nd generation)','iPad7,1/iPad7,2','A1670/A1671',''),(41,1,'2020-03-01 05:29:22.136403','iPad Pro 10.5-inch','iPad7,3/iPad7,4','A1701/A1709',''),(42,1,'2020-03-01 05:29:59.924621','iPad Pro 12.9-inch (3rd generation)','iPad8,5/iPad8,6/iPad8,7/iPad8,8','A1876/A2014/A1895/A1983',''),(43,1,'2020-03-01 05:30:35.060748','iPad Pro 11-inch','iPad8,1/iPad8,2/iPad8,3/iPad8,4','A1980/A2013/A1934/A1979',''),(44,1,'2020-03-01 05:31:42.358914','Apple TV HD','AppleTV5,3','A1625',''),(45,1,'2020-03-01 05:32:00.585136','Apple TV 4K','AppleTV6,2','A1842','');"
        ),
        migrations.RunSQL(
            "SET FOREIGN_KEY_CHECKS = 1;"
        ),
    ]
